This forum is closed to new posts and
responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:
RE: Compare 2 dates ~Umberto Nongeroson 24.Dec.03 02:34 PM a Web browser Domino Designer 6.0.1All Platforms
First, you need to find out exactly what value -- and what datatype of value -- is in that field. Use the Document Properties dialog from a view to examine the field value.
Rod's formula looks OK to me -- it assumes that dates are formatted dd/mm/yyyy on your computer, but based on your original posting it looks like they are. Are you sure you didn't leave out the square brackets or anything?
You might try putting in some debugging code so that you can tell which part of the expression is failing. E.g.:
Also, you said that it's a "computed" field. Did you know that computed fields are not recalculated when opening an existing document? Only when you edit the document, and refresh or save it, will Notes display a new value. The debugging code will also help you to determine when the formula is actually being evaluated.
Return to top
. . . . . . RE: Compare 2 dates (~Bill Frokimari... 24.Dec.03)
Print this page
